﻿#! /bin/bash

./ExtractFromWebservice.sh

for i in {0..0}; do
	stockId=`printf "6%05d" $i`	
     
	stockCode=$stockId".ss"
	./StockInfoLoad.sh $stockId".ss" stock/stock@orcl
done

sqlplus stock/stock@orcl << end_sql
  set ver off
	 @../sql/CaculateProcess.sql
  exit
end_sql
 